Debug Message - Perch Runway 3.1.7 |
[99] SELECT p.pagePath, pr.routePattern, pr.routeRegExp, p.pageTemplate, pr.routeOrder, s.settingValue AS siteOffline
FROM perch3_pages p LEFT JOIN perch3_page_routes pr ON p.pageID=pr.pageID LEFT JOIN perch3_settings s ON s.settingID='siteOffline'
UNION SELECT NULL AS pagePath, pr2.routePattern, pr2.routeRegExp, pr2.templatePath AS pageTemplate, pr2.routeOrder, NULL AS siteOffline
FROM perch3_page_routes pr2 WHERE templateID!=0 ORDER BY routeOrder ASC, pagePath ASC |
Matched route: shop/category/[slug:category]/[slug:subCategory] |
Using master page: /templates/pages/shop/categories/categories.php |
Page arguments: Array
(
[0] => /shop/category/domestic/sub-surface-flood-protection
[category] => domestic
[1] => domestic
[subCategory] => sub-surface-flood-protection
[2] => sub-surface-flood-protection
) |
[1] SELECT * FROM perch3_pages WHERE pagePath='/shop/category' LIMIT 1 |
[55] SELECT DISTINCT settingID, settingValue FROM perch3_settings WHERE userID=0 |
[1] SELECT locationID FROM perch3_shop_tax_locations WHERE locationIsHome=1 LIMIT 1 |
INSERT INTO perch3_shop_cart(memberID,locationID,currencyID,cartPricing,cartProperties) VALUES(NULL,'1',47,'standard','[]') |
[1] SELECT * FROM perch3_shop_cart WHERE cartID=1805625 |
[1] SELECT * FROM perch3_shop_cart WHERE cartID=1805625 |
[nil] SELECT * FROM perch3_shop_sales
WHERE saleFrom<='2025-09-04 06:04:00' AND saleTo>'2025-09-04 06:04:00' AND saleActive=1 AND saleDeleted IS NULL
ORDER BY saleOrder ASC |
[1] SELECT setID FROM perch3_category_sets WHERE setSlug='products' LIMIT 1 |
[1] SELECT main.* FROM perch3_categories main WHERE 1=1 AND (catSlug='domestic') AND setID=1 ORDER BY catTreePosition ASC |
[1] Using template: /templates/categories/category_title.html |
[1] SELECT setID FROM perch3_category_sets WHERE setSlug='products' LIMIT 1 |
[1] SELECT main.* FROM perch3_categories main WHERE 1=1 AND (catSlug='sub-surface-flood-protection') AND setID=1 ORDER BY catTreePosition ASC |
[1] Using template: /templates/categories/category_title.html |
[1] SELECT setID FROM perch3_category_sets WHERE setSlug='products' LIMIT 1 |
[nil] SELECT main.* FROM perch3_categories main WHERE 1=1 AND (catSlug='') AND setID=1 ORDER BY catTreePosition ASC |
Using template: /templates/categories/category_title.html |
[1] SELECT setID FROM perch3_category_sets WHERE setSlug='products' LIMIT 1 |
[nil] SELECT main.* FROM perch3_categories main WHERE 1=1 AND (catSlug='') AND setID=1 ORDER BY catTreePosition ASC |
Using template: /templates/categories/category_title.html |
[1] SELECT setID FROM perch3_category_sets WHERE setSlug='products' LIMIT 1 |
[1] SELECT main.* FROM perch3_categories main WHERE 1=1 AND (catSlug='sub-surface-flood-protection') AND setID=1 ORDER BY catTreePosition ASC |
[1] Using template: /templates/categories/category_title.html |
[1] SELECT setID FROM perch3_category_sets WHERE setSlug='products' LIMIT 1 |
[1] SELECT main.* FROM perch3_categories main WHERE 1=1 AND (catSlug='sub-surface-flood-protection') AND setID=1 ORDER BY catTreePosition ASC |
[1] Using template: /templates/categories/category_id.html |
[1] SELECT setID FROM perch3_category_sets WHERE setSlug='products' LIMIT 1 |
[1] SELECT main.* FROM perch3_categories main WHERE 1=1 AND (catSlug='sub-surface-flood-protection') AND setID=1 ORDER BY catTreePosition ASC |
[1] Using template: /templates/categories/category_depth.html |
[1] SELECT regionID, regionTemplate, regionPage, regionRev AS rev FROM perch3_content_regions WHERE regionKey='Contact Details' AND (regionPage LIKE '%' OR regionPage='*') |
[1] SELECT * FROM ( SELECT idx.itemID, c.regionID, idx.pageID, c.itemJSON, idx2.indexValue as sortval FROM perch3_content_index idx
JOIN perch3_content_items c ON idx.itemID=c.itemID AND idx.itemRev=c.itemRev AND idx.regionID=c.regionID
JOIN perch3_content_index idx2 ON idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev AND idx2.indexKey='_order' WHERE ((idx.regionID=6 AND idx.itemRev=35)) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev
) as tbl GROUP BY itemID, pageID, itemJSON, sortval, regionID ORDER BY sortval ASC |
[1] Using template: /templates/content/_contact_details/site_name.html |
[1] SELECT * FROM ( SELECT idx.itemID, c.regionID, idx.pageID, c.itemJSON, idx2.indexValue as sortval FROM perch3_content_index idx
JOIN perch3_content_items c ON idx.itemID=c.itemID AND idx.itemRev=c.itemRev AND idx.regionID=c.regionID
JOIN perch3_content_index idx2 ON idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev AND idx2.indexKey='_order' WHERE ((idx.regionID=6 AND idx.itemRev=35)) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev
) as tbl GROUP BY itemID, pageID, itemJSON, sortval, regionID ORDER BY sortval ASC |
[1] Using template: /templates/content/_contact_details/site_description.html |
[1] SELECT * FROM ( SELECT idx.itemID, c.regionID, idx.pageID, c.itemJSON, idx2.indexValue as sortval FROM perch3_content_index idx
JOIN perch3_content_items c ON idx.itemID=c.itemID AND idx.itemRev=c.itemRev AND idx.regionID=c.regionID
JOIN perch3_content_index idx2 ON idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev AND idx2.indexKey='_order' WHERE ((idx.regionID=6 AND idx.itemRev=35)) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev
) as tbl GROUP BY itemID, pageID, itemJSON, sortval, regionID ORDER BY sortval ASC |
[1] Using template: /templates/content/_contact_details/tel_only.html |
Using template: /templates/pages/attributes/default.html |
[1] SELECT * FROM ( SELECT idx.itemID, c.regionID, idx.pageID, c.itemJSON, idx2.indexValue as sortval FROM perch3_content_index idx
JOIN perch3_content_items c ON idx.itemID=c.itemID AND idx.itemRev=c.itemRev AND idx.regionID=c.regionID
JOIN perch3_content_index idx2 ON idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev AND idx2.indexKey='_order' WHERE ((idx.regionID=6 AND idx.itemRev=35)) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev
) as tbl GROUP BY itemID, pageID, itemJSON, sortval, regionID ORDER BY sortval ASC |
[1] Using template: /templates/content/_contact_details/og_image.html |
Using template: /templates/pages/attributes/og_image.html |
------------------------------ Calculating cart ------------------------------ |
[1] SELECT * FROM perch3_shop_cart WHERE cartID=1805625 |
[1] SELECT * FROM perch3_shop_cart WHERE cartID=1805625 |
[1] SELECT * FROM perch3_shop_tax_locations WHERE locationID=1 AND locationDeleted IS NULL LIMIT 1 |
[1] SELECT locationID FROM perch3_shop_tax_locations WHERE locationIsHome=1 LIMIT 1 |
[1] SELECT * FROM perch3_shop_tax_locations WHERE locationID=1 AND locationDeleted IS NULL LIMIT 1 |
[1] SELECT * FROM perch3_shop_currencies WHERE currencyID=47 LIMIT 1 |
[1] SELECT COUNT(productID) AS product_count, SUM(itemQty) AS item_count FROM perch3_shop_cart_items WHERE cartID=1805625 |
Tax mode: exc |
[nil] SELECT * FROM perch3_shop_cart_items WHERE cartID=1805625 ORDER BY itemID ASC |
[1] SELECT * FROM ( SELECT idx.itemID, c.regionID, idx.pageID, c.itemJSON, idx2.indexValue as sortval FROM perch3_content_index idx
JOIN perch3_content_items c ON idx.itemID=c.itemID AND idx.itemRev=c.itemRev AND idx.regionID=c.regionID
JOIN perch3_content_index idx2 ON idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev AND idx2.indexKey='_order' WHERE ((idx.regionID=6 AND idx.itemRev=35)) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev
) as tbl GROUP BY itemID, pageID, itemJSON, sortval, regionID ORDER BY sortval ASC |
[1] Using template: /templates/content/_contact_details/contact_address_schema.html |
[1] SELECT regionID, regionTemplate, regionPage, regionRev AS rev FROM perch3_content_regions WHERE regionKey='I am looking for menu' AND (regionPage='/shop/category' OR regionPage='*') |
[1] SELECT * FROM ( SELECT idx.itemID, c.regionID, idx.pageID, c.itemJSON, idx2.indexValue as sortval FROM perch3_content_index idx
JOIN perch3_content_items c ON idx.itemID=c.itemID AND idx.itemRev=c.itemRev AND idx.regionID=c.regionID
JOIN perch3_content_index idx2 ON idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev AND idx2.indexKey='_order' WHERE ((idx.regionID=288 AND idx.itemRev=41)) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev
) as tbl GROUP BY itemID, pageID, itemJSON, sortval, regionID ORDER BY sortval ASC |
[6] Using template: /templates/content/_homepage/looking_for_menu.html |
[51] SELECT * FROM perch3_pages WHERE pageNew=0 AND pageHidden=0 AND pageDepth >=0 AND pageDepth<=2 ORDER BY pageTreePosition ASC |
[1] SELECT pageTreePosition FROM perch3_pages WHERE pagePath='/shop/category' LIMIT 1 |
[2] SELECT pageID FROM perch3_pages WHERE pageTreePosition IN ('000-012-002', '000-012', '000') ORDER BY pageTreePosition DESC |
Using template: /templates/navigation/main_nav.html |
[10] Using template: /templates/navigation/sub_nav.html |
[1] SELECT setID FROM perch3_category_sets WHERE setSlug='products' LIMIT 1 |
[1] SELECT main.* FROM perch3_categories main WHERE 1=1 AND (catSlug='sub-surface-flood-protection') AND setID=1 ORDER BY catTreePosition ASC |
[1] Using template: /templates/categories//products/product_category.html |
Using template: /templates/shop/products/views/product_block.html |
[1] SELECT * FROM perch3_categories WHERE catPath='products/domestic/sub-surface-flood-protection/' LIMIT 1 |
[6] SELECT DISTINCT idx.itemID FROM perch3_shop_index idx JOIN perch3_shop_products main ON idx.itemID=main.productID AND idx.itemKey='productID' AND ((idx.indexKey='_category' AND idx.indexValue LIKE 'products/domestic/sub-surface-flood-protection/%' OR idx.indexKey='_category' AND idx.indexValue='products/domestic/sub-surface-flood-protection/')) |
[5] SELECT tbl.* FROM ( SELECT idx.itemID, main.*, idx2.indexValue as sortval FROM perch3_shop_index idx
JOIN perch3_shop_products main ON idx.itemID=main.productID AND idx.itemKey='productID'
JOIN perch3_shop_index idx2 ON idx.itemID=idx2.itemID AND idx.itemKey='productID' AND idx2.indexKey='productOrder' AND idx.itemID IN ('30', '25', '53', '20', '19', '21') WHERE 1=1 AND idx.itemID=idx2.itemID AND idx.itemKey=idx2.itemKey GROUP BY idx.itemID, idx2.indexValue, productID ) as tbl WHERE (productDeleted IS NULL AND productStatus=1 AND parentID IS NULL) GROUP BY itemID, sortval ORDER BY sortval * 1 ASC |
[5] Using template: /templates/shop/products/views/product_block.html |
[1] SELECT setID FROM perch3_category_sets WHERE setSlug='products' LIMIT 1 |
Filtering query |
[1] SELECT main.* FROM perch3_categories main WHERE 1=1 AND (catParentID=0 AND catPath REGEXP '[[:<:]]domestic[[:>:]]') AND setID=1 ORDER BY catTreePosition ASC |
[0] SELECT setID FROM perch3_category_sets WHERE setSlug='' LIMIT 1 |
[3] SELECT main.* FROM perch3_categories main WHERE 1=1 AND (catParentID=1) ORDER BY catTreePosition ASC |
[0] SELECT setID FROM perch3_category_sets WHERE setSlug='' LIMIT 1 |
[nil] SELECT main.* FROM perch3_categories main WHERE 1=1 AND (catParentID=5) ORDER BY catTreePosition ASC |
Using template: /templates/categories/products/product_categories_list.html |
[0] SELECT setID FROM perch3_category_sets WHERE setSlug='' LIMIT 1 |
[nil] SELECT main.* FROM perch3_categories main WHERE 1=1 AND (catParentID=6) ORDER BY catTreePosition ASC |
Using template: /templates/categories/products/product_categories_list.html |
[0] SELECT setID FROM perch3_category_sets WHERE setSlug='' LIMIT 1 |
[nil] SELECT main.* FROM perch3_categories main WHERE 1=1 AND (catParentID=7) ORDER BY catTreePosition ASC |
Using template: /templates/categories/products/product_categories_list.html |
[3] Using template: /templates/categories/products/product_categories_list.html |
[1] Using template: /templates/categories/products/product_categories_list.html |
[1] SELECT setID FROM perch3_category_sets WHERE setSlug='products' LIMIT 1 |
Filtering query |
[1] SELECT main.* FROM perch3_categories main WHERE 1=1 AND (catParentID=0 AND catPath NOT REGEXP '[[:<:]]domestic[[:>:]]') AND setID=1 ORDER BY catTreePosition ASC |
[1] Using template: /templates/categories/products/product_categories_shop.html |
[1] SELECT * FROM ( SELECT idx.itemID, c.regionID, idx.pageID, c.itemJSON, idx2.indexValue as sortval FROM perch3_content_index idx
JOIN perch3_content_items c ON idx.itemID=c.itemID AND idx.itemRev=c.itemRev AND idx.regionID=c.regionID
JOIN perch3_content_index idx2 ON idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev AND idx2.indexKey='_order' WHERE ((idx.regionID=6 AND idx.itemRev=35)) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev
) as tbl GROUP BY itemID, pageID, itemJSON, sortval, regionID ORDER BY sortval ASC |
[1] Using template: /templates/content/_contact_details/site_name.html |
[1] SELECT * FROM ( SELECT idx.itemID, c.regionID, idx.pageID, c.itemJSON, idx2.indexValue as sortval FROM perch3_content_index idx
JOIN perch3_content_items c ON idx.itemID=c.itemID AND idx.itemRev=c.itemRev AND idx.regionID=c.regionID
JOIN perch3_content_index idx2 ON idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev AND idx2.indexKey='_order' WHERE ((idx.regionID=6 AND idx.itemRev=35)) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev
) as tbl GROUP BY itemID, pageID, itemJSON, sortval, regionID ORDER BY sortval ASC |
[1] Using template: /templates/content/_contact_details/tel_only_formatted.html |
Using template: /templates/pages/attributes/hide_enquiry.html |
[1] SELECT * FROM ( SELECT idx.itemID, c.regionID, idx.pageID, c.itemJSON, idx2.indexValue as sortval FROM perch3_content_index idx
JOIN perch3_content_items c ON idx.itemID=c.itemID AND idx.itemRev=c.itemRev AND idx.regionID=c.regionID
JOIN perch3_content_index idx2 ON idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev AND idx2.indexKey='_order' WHERE ((idx.regionID=6 AND idx.itemRev=35)) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev
) as tbl GROUP BY itemID, pageID, itemJSON, sortval, regionID ORDER BY sortval ASC |
[13] Using template: /templates/content//_contact_details/accreditations.html |
[1] SELECT * FROM ( SELECT idx.itemID, c.regionID, idx.pageID, c.itemJSON, idx2.indexValue as sortval FROM perch3_content_index idx
JOIN perch3_content_items c ON idx.itemID=c.itemID AND idx.itemRev=c.itemRev AND idx.regionID=c.regionID
JOIN perch3_content_index idx2 ON idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev AND idx2.indexKey='_order' WHERE ((idx.regionID=6 AND idx.itemRev=35)) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev
) as tbl GROUP BY itemID, pageID, itemJSON, sortval, regionID ORDER BY sortval ASC |
[1] Using template: /templates/content//_contact_details/tel_email.html |
[1] SELECT * FROM ( SELECT idx.itemID, c.regionID, idx.pageID, c.itemJSON, idx2.indexValue as sortval FROM perch3_content_index idx
JOIN perch3_content_items c ON idx.itemID=c.itemID AND idx.itemRev=c.itemRev AND idx.regionID=c.regionID
JOIN perch3_content_index idx2 ON idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev AND idx2.indexKey='_order' WHERE ((idx.regionID=6 AND idx.itemRev=35)) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev
) as tbl GROUP BY itemID, pageID, itemJSON, sortval, regionID ORDER BY sortval ASC |
[1] Using template: /templates/content//_contact_details/address_only.html |
[1] SELECT * FROM ( SELECT idx.itemID, c.regionID, idx.pageID, c.itemJSON, idx2.indexValue as sortval FROM perch3_content_index idx
JOIN perch3_content_items c ON idx.itemID=c.itemID AND idx.itemRev=c.itemRev AND idx.regionID=c.regionID
JOIN perch3_content_index idx2 ON idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev AND idx2.indexKey='_order' WHERE ((idx.regionID=6 AND idx.itemRev=35)) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev
) as tbl GROUP BY itemID, pageID, itemJSON, sortval, regionID ORDER BY sortval ASC |
[1] Using template: /templates/content//_contact_details/address_only_repeater_limited.html |
[10] SELECT * FROM perch3_pages WHERE pageNew=0 AND pageHidden=0 AND pageDepth >=0 AND pageDepth<=1 ORDER BY pageTreePosition ASC |
[1] SELECT pageTreePosition FROM perch3_pages WHERE pagePath='/shop/category' LIMIT 1 |
[2] SELECT pageID FROM perch3_pages WHERE pageTreePosition IN ('000-012-002', '000-012', '000') ORDER BY pageTreePosition DESC |
[10] Using template: /templates/navigation/nav_lis_only.html |
[1] SELECT pageID, pageParentID, pageDepth, pageTreePosition FROM perch3_pages WHERE pagePath='/foot-links' OR pageSortPath='/foot-links' LIMIT 1 |
[4] SELECT * FROM perch3_pages WHERE pageNew=0 AND pageHidden=0 AND pageTreePosition LIKE '000-018%' AND pageDepth >=1 AND pageDepth<=2 ORDER BY pageTreePosition ASC |
[1] SELECT pageTreePosition FROM perch3_pages WHERE pagePath='/shop/category' LIMIT 1 |
[2] SELECT pageID FROM perch3_pages WHERE pageTreePosition IN ('000-012-002', '000-012', '000') ORDER BY pageTreePosition DESC |
[4] Using template: /templates/navigation/nav_lis_only.html |
[1] SELECT * FROM ( SELECT idx.itemID, c.regionID, idx.pageID, c.itemJSON, idx2.indexValue as sortval FROM perch3_content_index idx
JOIN perch3_content_items c ON idx.itemID=c.itemID AND idx.itemRev=c.itemRev AND idx.regionID=c.regionID
JOIN perch3_content_index idx2 ON idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev AND idx2.indexKey='_order' WHERE ((idx.regionID=6 AND idx.itemRev=35)) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev
) as tbl GROUP BY itemID, pageID, itemJSON, sortval, regionID ORDER BY sortval ASC |
[1] Using template: /templates/content//_contact_details/socials.html |
[1] SELECT * FROM ( SELECT idx.itemID, c.regionID, idx.pageID, c.itemJSON, idx2.indexValue as sortval FROM perch3_content_index idx
JOIN perch3_content_items c ON idx.itemID=c.itemID AND idx.itemRev=c.itemRev AND idx.regionID=c.regionID
JOIN perch3_content_index idx2 ON idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev AND idx2.indexKey='_order' WHERE ((idx.regionID=288 AND idx.itemRev=41)) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev
) as tbl GROUP BY itemID, pageID, itemJSON, sortval, regionID ORDER BY sortval ASC |
[6] Using template: /templates/content/_homepage/looking_for_menu.html |
[51] SELECT * FROM perch3_pages WHERE pageNew=0 AND pageHidden=0 AND pageDepth >=0 AND pageDepth<=2 ORDER BY pageTreePosition ASC |
[1] SELECT pageTreePosition FROM perch3_pages WHERE pagePath='/shop/category' LIMIT 1 |
[2] SELECT pageID FROM perch3_pages WHERE pageTreePosition IN ('000-012-002', '000-012', '000') ORDER BY pageTreePosition DESC |
Using template: /templates/navigation/main_nav.html |
[10] Using template: /templates/navigation/sub_nav.html |
[1] SELECT * FROM ( SELECT idx.itemID, c.regionID, idx.pageID, c.itemJSON, idx2.indexValue as sortval FROM perch3_content_index idx
JOIN perch3_content_items c ON idx.itemID=c.itemID AND idx.itemRev=c.itemRev AND idx.regionID=c.regionID
JOIN perch3_content_index idx2 ON idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev AND idx2.indexKey='_order' WHERE ((idx.regionID=288 AND idx.itemRev=41)) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev
) as tbl GROUP BY itemID, pageID, itemJSON, sortval, regionID ORDER BY sortval ASC |
[6] Using template: /templates/content/_homepage/looking_for_menu.html |
[51] SELECT * FROM perch3_pages WHERE pageNew=0 AND pageHidden=0 AND pageDepth >=0 AND pageDepth<=2 ORDER BY pageTreePosition ASC |
[1] SELECT pageTreePosition FROM perch3_pages WHERE pagePath='/shop/category' LIMIT 1 |
[2] SELECT pageID FROM perch3_pages WHERE pageTreePosition IN ('000-012-002', '000-012', '000') ORDER BY pageTreePosition DESC |
Using template: /templates/navigation/main_nav.html |
[10] Using template: /templates/navigation/sub_nav.html |
Request time: 0.0432 |
Process time: 0.0428 |
Memory: 1.4184 |
Array
(
[type] => 8
[message] => Trying to access array offset on value of type null
[file] => /home/m3floodtec/webapps/m3floodtec-com/kpanel/addons/apps/pipit_catalog/runtime.php
[line] => 19
)
|